﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 商城管理实体类：fanli_shop 。
	/// </summary>
	[Serializable]
	public class fanli_shop
	{
		public fanli_shop()
		{}

		#region Model
		private int _id; //id
		private string _title; //商城名称
		private string _logoUrl; //logo地址
		private int _cataid; //商城类别
		private string _fanli; //返利程度
		private string _vipFanli; //vip返利
		private string _summary; //摘要
		private string _about; //详细介绍
		private string _notice; //注意事项
		private string _bbsUrl; //论坛链接
		private DateTime? _pubDate; //发布时间
		private int _sortid; //排序
		private string _lm; //所属联盟
		private string _gotoURl; //推广地址
		private int _status; //商城状态
		private string _ext1; //扩展1
		private string _ext2; //扩展2
		private string _ext3; //扩展3
		private string _ext4; //扩展4


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 商城名称
		/// </summary>
		public string title
		{
			set{ _title=value;}
			get{return _title;}
		}
        /// <summary>
		/// logo地址
		/// </summary>
		public string logoUrl
		{
			set{ _logoUrl=value;}
			get{return _logoUrl;}
		}
        /// <summary>
		/// 商城类别
		/// </summary>
		public int cataid
		{
			set{ _cataid=value;}
			get{return _cataid;}
		}
        /// <summary>
		/// 返利程度
		/// </summary>
		public string fanli
		{
			set{ _fanli=value;}
			get{return _fanli;}
		}
        /// <summary>
		/// vip返利
		/// </summary>
		public string vipFanli
		{
			set{ _vipFanli=value;}
			get{return _vipFanli;}
		}
        /// <summary>
		/// 摘要
		/// </summary>
		public string summary
		{
			set{ _summary=value;}
			get{return _summary;}
		}
        /// <summary>
		/// 详细介绍
		/// </summary>
		public string about
		{
			set{ _about=value;}
			get{return _about;}
		}
        /// <summary>
		/// 注意事项
		/// </summary>
		public string notice
		{
			set{ _notice=value;}
			get{return _notice;}
		}
        /// <summary>
		/// 论坛链接
		/// </summary>
		public string bbsUrl
		{
			set{ _bbsUrl=value;}
			get{return _bbsUrl;}
		}
        /// <summary>
		/// 发布时间
		/// </summary>
		public DateTime? pubDate
		{
			set{ _pubDate=value;}
			get{return _pubDate;}
		}
        /// <summary>
		/// 排序
		/// </summary>
		public int sortid
		{
			set{ _sortid=value;}
			get{return _sortid;}
		}
        /// <summary>
		/// 所属联盟
		/// </summary>
		public string lm
		{
			set{ _lm=value;}
			get{return _lm;}
		}
        /// <summary>
		/// 推广地址
		/// </summary>
		public string gotoURl
		{
			set{ _gotoURl=value;}
			get{return _gotoURl;}
		}
        /// <summary>
		/// 商城状态
		/// </summary>
		public int status
		{
			set{ _status=value;}
			get{return _status;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
        /// <summary>
		/// 扩展3
		/// </summary>
		public string ext3
		{
			set{ _ext3=value;}
			get{return _ext3;}
		}
        /// <summary>
		/// 扩展4
		/// </summary>
		public string ext4
		{
			set{ _ext4=value;}
			get{return _ext4;}
		}
		#endregion Model

		#region txt document
		/*
商城管理,shop
id,商城名称,logo地址,商城类别,返利程度,vip返利,摘要,详细介绍,注意事项,论坛链接,发布时间,排序,所属联盟,推广地址,商城状态,扩展1,扩展2,扩展3,扩展4
id,title,logoUrl,cataid,fanli,vipFanli,summary,about,notice,bbsUrl,pubDate,sortid,lm,gotoURl,status,ext1,ext2,ext3,ext4
i,c100,c256,i,c400,c400,c800,t,t,c256,d,i,c30,c256,i,c100,c100,c100,c100

--------------------------
-- 创建表[商城管理]开始: 
-- alter table  [fanli_shop] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_shop') drop table fanli_shop
  CREATE TABLE [fanli_shop] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [title] [varchar] (100),
	 [logoUrl] [varchar] (256),
	 [cataid] int,
	 [fanli] [varchar] (400),
	 [vipFanli] [varchar] (400),
	 [summary] [varchar] (800),
	 [about] [text],
	 [notice] [text],
	 [bbsUrl] [varchar] (256),
	 [pubDate] [datetime],
	 [sortid] int,
	 [lm] [varchar] (30),
	 [gotoURl] [varchar] (256),
	 [status] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100),
	 [ext3] [varchar] (100),
	 [ext4] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'商城管理 ',N'user',N'dbo',N'table',N'fanli_shop', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'商城名称',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'title'
 exec sp_addextendedproperty N'MS_Description',N'logo地址',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'logoUrl'
 exec sp_addextendedproperty N'MS_Description',N'商城类别',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'cataid'
 exec sp_addextendedproperty N'MS_Description',N'返利程度',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'fanli'
 exec sp_addextendedproperty N'MS_Description',N'vip返利',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'vipFanli'
 exec sp_addextendedproperty N'MS_Description',N'摘要',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'summary'
 exec sp_addextendedproperty N'MS_Description',N'详细介绍',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'about'
 exec sp_addextendedproperty N'MS_Description',N'注意事项',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'notice'
 exec sp_addextendedproperty N'MS_Description',N'论坛链接',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'bbsUrl'
 exec sp_addextendedproperty N'MS_Description',N'发布时间',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'pubDate'
 exec sp_addextendedproperty N'MS_Description',N'排序',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'sortid'
 exec sp_addextendedproperty N'MS_Description',N'所属联盟',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'lm'
 exec sp_addextendedproperty N'MS_Description',N'推广地址',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'gotoURl'
 exec sp_addextendedproperty N'MS_Description',N'商城状态',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'status'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'ext2'
 exec sp_addextendedproperty N'MS_Description',N'扩展3',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'ext3'
 exec sp_addextendedproperty N'MS_Description',N'扩展4',N'user',N'dbo',N'table',N'fanli_shop',N'column',N'ext4'

-- 创建表[商城管理]结束。 
--------------------------

		*/
		#endregion document
	}
}

